<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>GX College Social Networking</title>
</head>

<body>
<table width="753" height="366" border="0">
  <tr>
    <td bgcolor="#6699FF" height="34" colspan="7"><marquee>GX College Networking</marquee></td>
  </tr>
  <tr>
    <td bgcolor="#6699FF" width="139" height="43"><a href="/ProfessorHomePage.php">Homepage</a></td>
    <td bgcolor="#6699FF" width="133"><a href="/ProfessorHomePageProfile.php">Profile</a></td>
    <td bgcolor="#6699FF" width="108"><a href="/ProfessorHomePageAlbums.php">Albums</a></td>
    <td bgcolor="#6699FF" width="170"><a href="/ProfessorHomePageFriend.php">Friends</a></td>
    <td bgcolor="#6699FF" width="115"><a href="/ProfessorHomePageMessage.php">Messages</a></td>
    <td bgcolor="#6699FF" width="62"><a href="/logout.php">Logout</a></td>
    <td bgcolor="#6699FF" width="194">
    <form action="/ViewAllCandidateSearchProfessor.php" method="post">
Enter Candidate's first name:  
<input type="text"  name="firstname" />
<input type="submit" name="submit" value="submit" />
</form>
    </td>
  </tr>
  <tr>
    <td bgcolor="#6699FF" height="281">&nbsp;</td>
    <td colspan="5">
    <form action="/CheckAddPhoto2AlbumProfessor.php" method="post" enctype="multipart/form-data">
  <table width="726" border="0">
  <tr>
  <?php

session_start();
$cuid = $_SESSION['username'];
//$firstname = $_POST['firstname'];

$conn = oci_connect("gaurav", "gaurav", "xe"); 
$stmt = oci_parse($conn, "SELECT * FROM Album where cuid = '$cuid'");
oci_execute($stmt, OCI_DEFAULT);
print "Select an Album ID <br>";
echo "<select name=\"message\">\n";
while ($res = oci_fetch_row($stmt))
{
echo 'Message'.$res[0];
echo "\t<option value=\"".$res[0]."\">".$res[0]."</option>\n";
}
echo "</select>";



oci_close($conn);
?>
  </tr>
    <tr>
  <td bgcolor="#6699FF">Your Photo</td>
  <td bgcolor="#6699FF"><input type="file" name="empphoto"></td>
  <td bgcolor="#6699FF">&nbsp;</td>
</tr>
    <tr>
    <td bgcolor="#6699FF">Caption</td>
      <td bgcolor="#6699FF" colspan="2"><input type="text" name="caption" maxlength="12"/></td>
      <td bgcolor="#6699FF">&nbsp;</td>
    </tr>
    <tr>
      <td ><div align="right">
        <input type="submit" value="Upload!" />
      </div></td>
      <td>&nbsp;&nbsp;
      <input type="reset" value="Reset Data!" /></td>
      <td width="175">&nbsp;</td>
    </tr>
  </table>
  <p>&nbsp;</p>
</form>
    </td>
  </tr>
</table>
</body>
</html>